package com.dbdata.move.dao;

import com.dbdata.move.model.StudentClass;
import com.dbdata.move.vo.StudentClassVo;
import com.wksc.framework.dao.BaseDao;
import org.hibernate.Criteria;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.ProjectionList;
import org.hibernate.criterion.Projections;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @author Richard
 */
@Repository
public class StudentClassDao extends BaseDao {

    public List<StudentClassVo> findStuClassAll() {
        String sql = "SELECT t.ID AS id, t.CLASS_NAME AS name FROM student_class t " +
                "WHERE t.CLASS_CLASS IS NULL;";
        return listSql(sql, StudentClassVo.class);
    }
}
